<template>
	<view>
		<view class="uni-header">
			<view class="uni-group">
				<view class="uni-title"></view>
				<view class="uni-sub-title"></view>
			</view>
			<view class="flex-d-row ali-item-cen flex-x-bet w-100">
				<view class="back" style="width: 33.33%;">
					<view @click="navigateBack" class="ali-item-cen flex-center br-200 col-00ba31"
						style="width: 160rpx;height: 60rpx;line-height: 60rpx;border: 2rpx solid #14cc6033;">
						<uni-icons type="back" size="20" color="#14cc60"></uni-icons>
						<text class="fs-28">返回</text>
					</view>
				</view>
				<view class="text-ali-c" style="width: 33.33%;">{{activity_name || ''}}</view>
				<view class="uni-group"
					style="width: 33.33%;align-items: right;display: flex;justify-content: flex-end;">
					<!-- <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" /> -->
					<!-- <button class="uni-button" type="default" size="mini" @click="search">搜索</button> -->
					<!-- <button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length"
						@click="delTable">批量删除</button> -->
					<download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
						:type="exportExcel.type" :name="exportExcel.filename">
						<button class="uni-button" type="primary" size="mini">导出 Excel</button>
					</download-excel>
				</view>
			</view>
		</view>
		<view class="uni-container">
			<unicloud-db ref="udb" :collection="collectionList" :where="where" page-data="replace" :orderby="orderby"
				:getcount="true" :page-size="options.pageSize" :page-current="options.pageCurrent"
				v-slot:default="{data,pagination,loading,error,options}" :options="options" loadtime="manual"
				@load="onqueryload">
				<uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe
					type="selection" @selection-change="selectionChange">
					<uni-tr>
						<uni-th align="center">报名用户</uni-th>
						<uni-th align="center">用户ID</uni-th>
						<uni-th align="center">活动</uni-th>
						<uni-th align="center" filter-type="range"
							@filter-change="filterChange($event, 'signup_amount')" sortable
							@sort-change="sortChange($event, 'signup_amount')">报名费用</uni-th>
						<uni-th align="center" sortable @sort-change="sortChange($event, 'order_id')">付款订单</uni-th>
						<uni-th align="center" filter-type="range"
							@filter-change="filterChange($event, 'signup_status')" sortable
							@sort-change="sortChange($event, 'signup_status')">报名状态</uni-th>
						<uni-th align="center" filter-type="timestamp"
							@filter-change="filterChange($event, 'signup_time')" sortable
							@sort-change="sortChange($event, 'signup_time')">报名时间</uni-th>
					</uni-tr>
					<uni-tr v-for="(item,index) in data" :key="index">
						<uni-td align="center">{{item.user_id && item.user_id[0] && item.user_id[0].text}}</uni-td>
						<uni-td align="center">{{item.user_id && item.user_id[0] && item.user_id[0]._id}}</uni-td>
						<uni-td
							align="center">{{item.activity_id && item.activity_id[0] && item.activity_id[0].text}}</uni-td>
						<uni-td align="center">{{item.signup_amount?item.signup_amount/100 + '元' : '-'}}</uni-td>
						<uni-td align="center">{{item.order_id || '-'}}</uni-td>
						<uni-td
							align="center">{{item.signup_status == 0?'✅':item.signup_status == 1?'❌':'未知状态'}}</uni-td>
						<uni-td align="center">
							<uni-dateformat :threshold="[0, 0]" :date="item.signup_time"></uni-dateformat>
						</uni-td>
					</uni-tr>
				</uni-table>
				<view class="uni-pagination-box">
					<uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current"
						:total="pagination.count" @change="onPageChanged" />
				</view>
			</unicloud-db>
		</view>
	</view>
</template>

<script>
	import {
		enumConverter,
		filterToWhere
	} from '../../js_sdk/validator/qmy-activity-sign-up.js';

	const db = uniCloud.database()
	// 表查询配置
	const dbOrderBy = '' // 排序字段
	const dbSearchFields = ['user_id.text'] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
	// 分页配置
	const pageSize = 20
	const pageCurrent = 1

	const orderByMapping = {
		"ascending": "asc",
		"descending": "desc"
	}

	export default {
		data() {
			return {
				collectionList: [db.collection('qmy-activity-sign-up').field(
						'activity_id,signup_amount,order_id,signup_status,user_id,signup_time').getTemp(), db
					.collection('uni-id-users').field('nickname as text, _id').getTemp(), db.collection('qmy-activity')
					.field('name as text, _id').getTemp()
				],
				query: '',
				where: '',
				orderby: dbOrderBy,
				orderByFieldName: "",
				selectedIndexs: [],
				options: {
					pageSize,
					pageCurrent,
					filterData: {},
					...enumConverter
				},
				imageStyles: {
					width: 64,
					height: 64
				},
				exportExcel: {
					"filename": "qmy-activity-sign-up.xls",
					"type": "xls",
					"fields": {
						"报名用户": "user_id_text",
						"活动": "activity_id_text",
						"报名费用": "signup_amount",
						"付款订单": "order_id",
						"报名状态": "signup_status",
						"报名时间": "signup_time"
					}
				},
				exportExcelData: [],
				activity_id: '',
				activity_name: ''
			}
		},
		onLoad(e) {
			this._filter = {}
			this.activity_id = e.id
			this.where = `activity_id._id == "${this.activity_id}"`
			this.activity_name = e.name
		},
		onReady() {
			this.$refs.udb.loadData()
		},
		methods: {
			// 返回上一页或跳转到首页
			navigateBack() {
				const pages = getCurrentPages()

				if (pages.length > 1) {
					// 返回上一页
					uni.navigateBack(-1)
				} else {
					// 跳转到文章列表页
					uni.redirectTo({
						url: '/pages/index/index'
					})
				}
			},
			onqueryload(data) {
				this.exportExcelData = data.map(item => ({
					user_id_text: item.user_id && item.user_id[0] ? item.user_id[0].text : '',
					activity_id_text: item.activity_id && item.activity_id[0] ? item.activity_id[0].text : '',
					signup_amount: item.signup_amount,
					order_id: item.order_id,
					signup_status: item.signup_status,
					signup_time: item.signup_time
				}))
			},
			getWhere() {
				const query = this.query.trim()
				if (!query) {
					return ''
				}
				const queryRe = new RegExp(query, 'i')
				return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
			},
			search() {
				const newWhere = this.getWhere()
				this.where = newWhere
				this.$nextTick(() => {
					this.loadData()
				})
			},
			loadData(clear = true) {
				this.$refs.udb.loadData({
					clear
				})
			},
			onPageChanged(e) {
				this.selectedIndexs.length = 0
				this.$refs.table.clearSelection()
				this.$refs.udb.loadData({
					current: e.current
				})
			},
			navigateTo(url, clear) {
				// clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
				uni.navigateTo({
					url,
					events: {
						refreshData: () => {
							this.loadData(clear)
						}
					}
				})
			},
			// 多选处理
			selectedItems() {
				var dataList = this.$refs.udb.dataList
				return this.selectedIndexs.map(i => dataList[i]._id)
			},
			// 批量删除
			delTable() {
				this.$refs.udb.remove(this.selectedItems(), {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			// 多选
			selectionChange(e) {
				this.selectedIndexs = e.detail.index
			},
			confirmDelete(id) {
				this.$refs.udb.remove(id, {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			sortChange(e, name) {
				this.orderByFieldName = name;
				if (e.order) {
					this.orderby = name + ' ' + orderByMapping[e.order]
				} else {
					this.orderby = ''
				}
				this.$refs.table.clearSelection()
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			},
			filterChange(e, name) {
				this._filter[name] = {
					type: e.filterType,
					value: e.filter
				}
				let newWhere = filterToWhere(this._filter, db.command)
				if (Object.keys(newWhere).length) {
					this.where = newWhere
				} else {
					this.where = ''
				}
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			}
		}
	}
</script>

<style>
</style>